<?php
class Front_Index_Generic extends System_Db_Generic  {
// evaluate as php
	public function getLoginUser($username,$password){
		$db = Zend_Registry :: get("db");
		$statement = $db->prepare("exec dbo.sp_User_Logon_Verify '$username','$password'");
		$statement->execute();
		$results = $statement->fetchAll();
		return $results['0'];
	}
	
	public function getLoginDetail(){
		$db	= Zend_Registry :: get("db");
		$statement = $db->prepare("exec dbo.sp_User_Logon_info");
		$statement->execute();
		$results = $statement->fetchAll();
		return $results;
	}
}
?>